SELECT V1.[name] as 'Name', V1.[crdate] as 'CreateDate', V1.[filename] As 'FileName' 
FROM master.dbo.sysdatabases V1

select physical_name,type_desc from sys.database_files